﻿USE CORINA_DATA
GO

CREATE TABLE t_device_message (
    Id INT PRIMARY KEY IDENTITY,
    DeviceSn VARCHAR(20),
    Content VARCHAR(400),
	ProofValue VARCHAR(20),
	MobileOrIP VARCHAR(20),
    RecievedTime DATETIME DEFAULT(GETDATE()),
    TransType INT DEFAULT(2),
    SmsId INT DEFAULT(0),
    IsAnalysed BIT DEFAULT(0)
)